# employment/models.py
from sqlalchemy import Column, String, Integer
from ..database import Base


class Employment(Base):
    __tablename__ = "employment"

    student_id = Column(String(20), primary_key=True, comment="学生编号")
    student_name = Column(String(20), nullable=True, comment="学生姓名")
    class_name = Column(String(20), nullable=True, comment="学生班级")
    job_search_start = Column(String(20), nullable=True, comment='就业开放时间')
    offer_date = Column(String(20), nullable=True, comment='offer下放时间')
    company_name = Column(String(100), nullable=True, comment='就业公司名称')
    salary = Column(Integer, nullable=True, comment='工资')